﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="RoutingRecordsDS" targetNamespace="http://tempuri.org/RoutingRecordsDS.xsd" xmlns:mstns="http://tempuri.org/RoutingRecordsDS.xsd" xmlns="http://tempuri.org/RoutingRecordsDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RoutingTableConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RoutingTableConnectionString (Settings)" PropertyReference="ApplicationSettings.IpPbxImportRR.Properties.Settings.GlobalReference.Default.RoutingTableConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoutingRecordsTableAdapter" GeneratorDataComponentClassName="RoutingRecordsTableAdapter" Name="RoutingRecords" UserDataComponentName="RoutingRecordsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RoutingTableConnectionString (Settings)" DbObjectName="RoutingRecords$" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO `RoutingRecords$` (`RoutingRecordID`, `TrunkGroup`, `Enabled`, `Priority`, `Deny`, `Number`, `SourceNumber`, `SourceUser`, `SourceGroup`, `SourceLocation`, `StartTime`, `EndTime`, `Mondays`, `Tuesdays`, `Wednesdays`, `Thursdays`, `Fridays`, `Saturdays`, `Sundays`, `CBCPrefix`,  `NumRetries`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RoutingRecordID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="RoutingRecordID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TrunkGroup" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TrunkGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Enabled" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Enabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Priority" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Deny" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Deny" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceUser" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceGroup" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StartTime" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EndTime" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mondays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mondays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tuesdays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tuesdays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Wednesdays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Wednesdays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Thursdays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Thursdays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fridays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fridays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Saturdays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Saturdays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Sundays" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Sundays" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CBCPrefix" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CBCPrefix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NumRetries" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NumRetries" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        RoutingRecordID, TrunkGroup, Enabled, Priority, Deny, [Number], SourceNumber, SourceUser, SourceGroup, SourceLocation, StartTime, EndTime, Mondays, Tuesdays, Wednesdays, Thursdays, Fridays, 
                         Saturdays, Sundays, CBCPrefix, NumRetries
FROM            [RoutingRecords$]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoutingRecordID" DataSetColumn="RoutingRecordID" />
              <Mapping SourceColumn="TrunkGroup" DataSetColumn="TrunkGroup" />
              <Mapping SourceColumn="Enabled" DataSetColumn="Enabled" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Deny" DataSetColumn="Deny" />
              <Mapping SourceColumn="Number" DataSetColumn="Number" />
              <Mapping SourceColumn="SourceNumber" DataSetColumn="SourceNumber" />
              <Mapping SourceColumn="SourceUser" DataSetColumn="SourceUser" />
              <Mapping SourceColumn="SourceGroup" DataSetColumn="SourceGroup" />
              <Mapping SourceColumn="SourceLocation" DataSetColumn="SourceLocation" />
              <Mapping SourceColumn="StartTime" DataSetColumn="StartTime" />
              <Mapping SourceColumn="EndTime" DataSetColumn="EndTime" />
              <Mapping SourceColumn="Mondays" DataSetColumn="Mondays" />
              <Mapping SourceColumn="Tuesdays" DataSetColumn="Tuesdays" />
              <Mapping SourceColumn="Wednesdays" DataSetColumn="Wednesdays" />
              <Mapping SourceColumn="Thursdays" DataSetColumn="Thursdays" />
              <Mapping SourceColumn="Fridays" DataSetColumn="Fridays" />
              <Mapping SourceColumn="Saturdays" DataSetColumn="Saturdays" />
              <Mapping SourceColumn="Sundays" DataSetColumn="Sundays" />
              <Mapping SourceColumn="CBCPrefix" DataSetColumn="CBCPrefix" />
              <Mapping SourceColumn="NumRetries" DataSetColumn="NumRetries" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="RoutingRecordsDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="RoutingRecordsDS" msprop:Generator_DataSetName="RoutingRecordsDS" msprop:EnableTableAdapterManager="False">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="RoutingRecords" msprop:Generator_UserTableName="RoutingRecords" msprop:Generator_RowDeletedName="RoutingRecordsRowDeleted" msprop:Generator_RowChangedName="RoutingRecordsRowChanged" msprop:Generator_RowClassName="RoutingRecordsRow" msprop:Generator_RowChangingName="RoutingRecordsRowChanging" msprop:Generator_RowEvArgName="RoutingRecordsRowChangeEvent" msprop:Generator_RowEvHandlerName="RoutingRecordsRowChangeEventHandler" msprop:Generator_TableClassName="RoutingRecordsDataTable" msprop:Generator_TableVarName="tableRoutingRecords" msprop:Generator_RowDeletingName="RoutingRecordsRowDeleting" msprop:Generator_TablePropName="RoutingRecords">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoutingRecordID" msprop:Generator_UserColumnName="RoutingRecordID" msprop:Generator_ColumnPropNameInRow="RoutingRecordID" msprop:Generator_ColumnVarNameInTable="columnRoutingRecordID" msprop:Generator_ColumnPropNameInTable="RoutingRecordIDColumn" type="xs:string" minOccurs="0" />
              <xs:element name="TrunkGroup" msprop:Generator_UserColumnName="TrunkGroup" msprop:Generator_ColumnPropNameInRow="TrunkGroup" msprop:Generator_ColumnVarNameInTable="columnTrunkGroup" msprop:Generator_ColumnPropNameInTable="TrunkGroupColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Enabled" msprop:Generator_UserColumnName="Enabled" msprop:Generator_ColumnPropNameInRow="Enabled" msprop:Generator_ColumnVarNameInTable="columnEnabled" msprop:Generator_ColumnPropNameInTable="EnabledColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Deny" msprop:Generator_UserColumnName="Deny" msprop:Generator_ColumnPropNameInRow="Deny" msprop:Generator_ColumnVarNameInTable="columnDeny" msprop:Generator_ColumnPropNameInTable="DenyColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceNumber" msprop:Generator_UserColumnName="SourceNumber" msprop:Generator_ColumnPropNameInRow="SourceNumber" msprop:Generator_ColumnVarNameInTable="columnSourceNumber" msprop:Generator_ColumnPropNameInTable="SourceNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceUser" msprop:Generator_UserColumnName="SourceUser" msprop:Generator_ColumnPropNameInRow="SourceUser" msprop:Generator_ColumnVarNameInTable="columnSourceUser" msprop:Generator_ColumnPropNameInTable="SourceUserColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceGroup" msprop:Generator_UserColumnName="SourceGroup" msprop:Generator_ColumnPropNameInRow="SourceGroup" msprop:Generator_ColumnVarNameInTable="columnSourceGroup" msprop:Generator_ColumnPropNameInTable="SourceGroupColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceLocation" msprop:Generator_UserColumnName="SourceLocation" msprop:Generator_ColumnPropNameInRow="SourceLocation" msprop:Generator_ColumnVarNameInTable="columnSourceLocation" msprop:Generator_ColumnPropNameInTable="SourceLocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartTime" msprop:Generator_UserColumnName="StartTime" msprop:Generator_ColumnPropNameInRow="StartTime" msprop:Generator_ColumnVarNameInTable="columnStartTime" msprop:Generator_ColumnPropNameInTable="StartTimeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="EndTime" msprop:Generator_UserColumnName="EndTime" msprop:Generator_ColumnPropNameInRow="EndTime" msprop:Generator_ColumnVarNameInTable="columnEndTime" msprop:Generator_ColumnPropNameInTable="EndTimeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Mondays" msprop:Generator_UserColumnName="Mondays" msprop:Generator_ColumnPropNameInRow="Mondays" msprop:Generator_ColumnVarNameInTable="columnMondays" msprop:Generator_ColumnPropNameInTable="MondaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Tuesdays" msprop:Generator_UserColumnName="Tuesdays" msprop:Generator_ColumnPropNameInRow="Tuesdays" msprop:Generator_ColumnVarNameInTable="columnTuesdays" msprop:Generator_ColumnPropNameInTable="TuesdaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Wednesdays" msprop:Generator_UserColumnName="Wednesdays" msprop:Generator_ColumnPropNameInRow="Wednesdays" msprop:Generator_ColumnVarNameInTable="columnWednesdays" msprop:Generator_ColumnPropNameInTable="WednesdaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Thursdays" msprop:Generator_UserColumnName="Thursdays" msprop:Generator_ColumnPropNameInRow="Thursdays" msprop:Generator_ColumnVarNameInTable="columnThursdays" msprop:Generator_ColumnPropNameInTable="ThursdaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Fridays" msprop:Generator_UserColumnName="Fridays" msprop:Generator_ColumnPropNameInRow="Fridays" msprop:Generator_ColumnVarNameInTable="columnFridays" msprop:Generator_ColumnPropNameInTable="FridaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Saturdays" msprop:Generator_UserColumnName="Saturdays" msprop:Generator_ColumnPropNameInRow="Saturdays" msprop:Generator_ColumnVarNameInTable="columnSaturdays" msprop:Generator_ColumnPropNameInTable="SaturdaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="Sundays" msprop:Generator_UserColumnName="Sundays" msprop:Generator_ColumnPropNameInRow="Sundays" msprop:Generator_ColumnVarNameInTable="columnSundays" msprop:Generator_ColumnPropNameInTable="SundaysColumn" type="xs:string" default="0" minOccurs="0" />
              <xs:element name="CBCPrefix" msprop:Generator_UserColumnName="CBCPrefix" msprop:Generator_ColumnPropNameInRow="CBCPrefix" msprop:Generator_ColumnVarNameInTable="columnCBCPrefix" msprop:Generator_ColumnPropNameInTable="CBCPrefixColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumRetries" msprop:Generator_UserColumnName="NumRetries" msprop:Generator_ColumnPropNameInRow="NumRetries" msprop:Generator_ColumnVarNameInTable="columnNumRetries" msprop:Generator_ColumnPropNameInTable="NumRetriesColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>